Here I will be doing Exploratory Data Analysis of BIG BASKET

Importing Necessary Libararies

I imported the data now Lets Find out how many categories and subcategories are here

There are Total 11 Categories

And Total 90 sub-Categories

And Total 426 Types

Now I will Work on null values

As from above chart most of the null values are in rating column and some in description column also lets find out that in percentages form

Ohh there are around 31% of values in rating column are null , so i will take care of these null values by using mean rating of that respected category.

Null values decreases lets check in percentage again

Now it is only 3 percent earlier it was 31% now we can proceed further.

Now I will try to find out average of Rating, Sales Price, Market Price per category

in above table i find out averages and sort them in rating values in descresing order

Now lets understand Further with the helps of graphs and visuals

Ranking of categories WRT Rating

Ranking of Categories WRT Avg Market price

Ranking of Categories WRT avg sales price

Moving towars sub category

Avg Rating, Sale Price & market_price per sub-category

there are around 90 Sub Category so bar graph will not be a good choice i will try Scatter Plot chart

Highest sale price sub-category is Cookware Non stick while lowest is vegetables